package com.jusu.dao;

import java.util.Map;

import org.apache.ibatis.jdbc.SQL;

public class ShopSqlProvider {

	public String show(Map map)
	{
		final String choise =(String)map.get("choise");
		return new SQL(){{
			//SELECT("sid,sname,brand,salesvolume,price,width,ssize,technics,surplus,pic1,pic2,pic3,hot");
			SELECT("width");
			FROM("shops");
			//System.out.println(choise);
			if("width".equals(choise))
			{
				GROUP_BY("width");
				ORDER_BY("width");
			}else if("sSize".equals(choise)){
				GROUP_BY("sSize");
				ORDER_BY("sSize");
			}
		}}.toString();
	}
}
